xx, 460 pages : 23 cm

SQL: Visual Quickstart Guide teaches SQL---the language of databases---to beginning and intermediate programmers. With SQL, you can create, alter, and drop tables, indexes, and views; insert, update, query, and delete data; and execute transactions to maintain the integrity of those data. This book covers the relational model, the core language for ANSI/ISO (standard) SQL:2003, and product-specific variations for Microsoft Access, Microsoft SQL Server, Oracle, IBM DB2, MySQL, and postgresSQL. Hundreds of examples of varied difficulty encourage you to experiment and explore. The book's split-page format separates examples from the flow of the text and its extensive cross references and index make it a good quick reference for experienced programmers. This updated edition covers SQL:2003 (the latest SQL standard) and the most recent DBMS releases, adds IBM DB2 coverage, and includes new programming tips, new sidebars on subtle or advanced topics, and other odds and ends

"Code tested on Access, SQL Server, Oracle, DB2, MySQL, and PostgreSQL"--Cover

Includes index

DBMS specifics -- The relational model -- SQL basics -- Retrieving data from a table -- Operators and functions -- Summarizing and grouping data -- Joins -- Subqueries -- Set operations -- Inserting, updating, and deleting rows -- Creating, altering, and dropping tables -- Indexes -- Views -- Transactions -- Appendix A. Creating the sample database -- Appendix B. SQL keywords

plus-circle Add Review

comment

Reviews